SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412762 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412762 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (994734,936211,349880,238675,19755,229389,787462,291786,935683,635209,796085,131584,1010711,946778,889025,48100,860288,654875,935662,950356,737689,163740,272723,580593,53884,955310,987441,737991,333373,504606,213991,353546,115535,924154,632678,966949,776185,357524,716102,125187,239919,715587,685394,353278,13041,994724,827242,155271,1017335,172952,1038957,99197,753387,729179,18710,716329,276170,4875,663471,161372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412762 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412762 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]