SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285710 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285710 [ RunTime:0.002942s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786434,153863,279733,303993,962632,190674,642095,944272,180957,523770,657047,292123,323024,301660,1011918,533441,1047811,194470,648392,969174,56037,500106,501054,321408,349421,88749,675230,180813,656184,554241,403564,381374,344640,504861,562578,891556,635529,778218,208063,653474,696272,351990,782989,656509,59335,73309,3128,165163,707398,71767,753253,696003,300509,437913,634464,450945,395010,128010,371930,522743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001365s ]