SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268801 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268801 [ RunTime:0.004255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199070,206757,275545,372307,769848,300391,184804,938251,1015525,251,335841,95911,655402,894343,882196,838995,480381,1029024,162638,604293,1034052,699321,597715,826759,781531,949061,556583,727388,238692,300134,320698,773473,753901,249027,55500,808776,407743,121515,945250,433298,225358,411881,433966,724805,633849,99018,64465,243130,478574,314221,608413,728844,60881,582980,539586,292963,922872,848313,471510,423930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]