SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016511 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016511 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188808,518404,404779,650859,14468,853673,878482,443986,954549,1047362,434197,453063,326432,749952,34606,503554,495974,30700,569914,410718,714458,141083,386361,205743,561584,246719,712889,230406,905649,49788,813165,972147,485979,785525,138132,794262,752038,609085,662791,186916,45379,160689,889124,118149,598660,290616,1022866,150635,498654,8417,116354,205952,181742,269191,584337,438643,1045354,460899,1017776,913051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002027s ]