SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651895 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651895 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130160,408020,115724,223736,561072,103742,173534,14734,119235,641979,1002504,710899,505065,997009,250905,948490,944800,229758,415186,687393,1011146,988632,459120,825089,722261,240714,418749,360968,861566,66143,789509,790157,1012388,708318,537689,55155,285195,517191,524383,663907,921135,200009,343974,192466,267285,151898,77472,782752,276728,252173,208078,242650,155787,382585,1011329,941173,594850,143849,63872,1033776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]