SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019647 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019647 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763778,299883,485770,858000,107353,999335,128762,861737,154804,582734,176034,1027652,431353,306503,12188,292184,322951,68950,961674,354290,188883,397331,756855,400424,1003109,708136,759951,782087,375566,861137,358204,1011616,613187,440498,100410,1019894,827180,65450,589215,761064,491117,1041188,1035497,347436,1027566,545364,1011292,617353,514322,721138,39690,262151,194826,339345,771334,104527,693429,967179,210945,449328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]