SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905798 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905798 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608600,76021,59695,931018,149888,478220,382798,912830,238018,870981,627413,683087,68681,791373,633949,25640,453670,664668,899351,550118,259522,1048905,797612,294914,433678,747629,898018,706822,76346,543866,995132,521714,246374,499184,365789,324140,309326,754780,871326,545413,1019237,278238,443119,11945,541235,652181,18165,533460,767539,353922,494383,543136,508275,279374,618215,534098,919640,415089,512988,499428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]