SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515354 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515354 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809234,804088,994212,917677,449056,739024,987962,646854,1043530,517921,104000,857031,33406,121494,413265,175352,711044,1000048,436172,900172,502767,691814,940618,573454,875788,192334,400769,370712,547234,494183,397689,533837,116984,62303,285045,155412,289822,512822,335872,911888,599316,587652,194995,279745,283902,734922,1039655,781162,106743,925404,783085,361899,143042,351639,732831,890512,295505,971599,687747,263266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]