SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508771 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508771 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620310,671809,531914,374360,740246,60426,77266,74609,73480,1003087,42968,134193,836661,810422,818495,910052,201790,583900,120750,641018,810643,743162,357122,48994,622263,737303,577115,857753,218413,605744,145622,401189,363848,554395,816905,143902,48294,406534,616824,237775,299317,593874,485283,436343,205270,63342,121304,105022,247725,590792,563457,890159,345071,195164,908749,823183,909375,845028,670254,859836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]