SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392004 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392004 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11425,1002238,498027,212965,1002710,704703,490148,47709,411432,190991,678500,613248,829782,948923,387926,929098,906833,443836,305067,1047345,928612,653184,491351,653783,262520,825826,220473,627066,833018,311126,151808,544169,148293,633913,924253,533052,726509,440560,890181,663737,585667,787449,400681,815677,223843,659677,607557,838252,216842,122991,702051,984105,723952,770347,269825,78583,880875,590518,882371,478910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000974s ]