SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562916 LIMIT 1 [ RunTime:0.000972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562916 [ RunTime:0.002284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670375,231900,922676,57251,245707,306874,73019,544484,243166,424332,110630,661006,115571,858738,645602,287835,187385,500756,350152,960224,1044956,874651,702526,645452,996728,747486,213171,761493,478137,462089,987221,302784,737670,910067,735092,278179,566507,97243,341804,109408,46740,972905,257720,966582,638915,974691,229440,386594,672486,35165,332691,854010,811452,46300,776450,481997,844201,1022039,870387,712185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]