SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527839 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527839 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278385,251668,139758,454543,501469,662146,378864,362071,297395,216529,462888,223414,431392,234480,138779,1011507,930998,373473,178854,561179,150060,106894,935477,869824,424189,944420,528345,641672,49569,470741,304570,157661,784621,629654,442400,896475,975658,217979,520927,80824,955560,757811,294332,724619,238539,77014,114020,271355,434757,346861,732310,362286,429400,261616,292716,804303,353901,633650,866114,817838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]