SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336400 LIMIT 1 [ RunTime:0.000632s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336400 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409920,606745,258008,235335,514456,1031943,948219,86839,29152,1048176,149615,998436,472891,638297,830693,387265,83426,410248,883999,670770,37151,300971,925108,362102,150800,1040277,1006042,906142,554112,10513,514244,973485,1046113,647433,888490,225762,506146,675571,764251,585232,565867,386574,292216,941802,996961,925047,327547,5433,833886,685155,891109,769801,184748,486469,115874,360594,1008488,778209,368667,1000631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]