SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020045 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020045 [ RunTime:0.003073s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931285,670997,797711,761763,783931,349460,281120,591657,449380,170243,951929,804537,468219,233239,808457,440757,533445,142068,317505,976585,632328,456315,11679,133279,298205,17358,446139,955473,12622,440045,228477,67519,115777,626849,505956,552884,705221,802046,928449,8544,635910,1034267,236121,689713,132652,617926,443026,310488,1022882,994275,752352,1007800,540872,400019,874354,199641,546101,999549,74053,955188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]