SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286181 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286181 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150749,25474,660674,210255,991356,429312,863552,107898,1031357,582214,93821,112998,150157,658998,931087,65890,297402,1006707,1033495,348960,926443,1006005,70090,380284,364047,356775,92979,1044338,800350,486228,460754,493462,316679,881741,515062,566259,1043331,693192,906227,168471,772776,996874,370834,957165,344185,934952,89257,196856,257388,1012003,802706,120464,703076,900056,884018,29114,597458,832328,485492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]