SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509207 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509207 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792907,772190,182506,109926,835416,24551,432370,773635,473250,908910,191624,205962,733354,210075,86164,273689,727582,550441,612963,564910,1014541,917796,180140,432980,510734,933848,258476,1033281,636022,994722,298755,597943,635767,26867,649748,832938,390283,922743,1043335,768465,110272,547600,704423,609968,595654,888589,158842,762373,257733,554300,366202,388002,106870,802309,1047819,116475,710141,685204,828591,159882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]