SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386987 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386987 [ RunTime:0.002947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360962,887100,1025176,696057,726858,643053,982312,506094,673632,832884,942988,172177,450472,590970,492799,520621,109310,669710,179601,1041897,885069,374329,881131,757244,439780,811497,930825,279432,436947,80905,92562,225217,378928,382734,131593,456305,1045219,142113,535054,739236,396083,1038042,502247,158434,920484,3016,359617,411349,956769,621560,1036576,1009977,41055,79226,364656,173374,141046,490860,704950,986586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]