SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.013188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540036 LIMIT 1 [ RunTime:0.001467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540036 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169402,864128,433656,343445,331433,177596,1009100,269503,887792,982521,725909,721105,417137,205919,1037683,122570,19362,1021941,55499,57059,878904,294625,817413,121775,695153,725133,560492,928990,706273,495827,26580,396730,956403,354048,761384,11522,410090,79313,394146,397254,932989,407199,301452,758151,389509,241890,988548,576558,224144,243866,197531,790884,823270,699871,890966,549163,501829,833428,9510,736357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]