SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002890s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563313 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563313 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54665,1005893,1033899,172488,1038835,21079,829383,282292,21835,865505,316238,567567,138354,481164,764788,642855,300692,484000,322656,764300,694952,770959,431596,1027289,185147,64334,159148,62065,471484,872810,1014786,585842,744051,391203,373316,104830,3621,614658,224749,917323,192386,653527,817336,895881,732745,650591,831966,539613,340795,169656,758089,843911,308429,901428,127577,147132,233470,1030919,502661,394329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]