SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200334 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200334 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507490,530250,529703,974970,29938,333660,192830,605801,89874,701745,115699,164670,859026,834578,243879,813706,219545,1029029,129677,570484,541998,932900,258894,26326,135611,837558,115180,894808,1042747,391253,635672,860144,506592,811780,655367,317259,22239,1015333,473209,490932,217330,803089,665105,209340,874927,960539,106386,264498,90404,613498,548995,437915,1044588,264822,535583,438368,258311,7634,657436,1012631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200334 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200334 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]