SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10222 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10222 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814833,1014340,432900,826041,147345,258103,375692,1015682,946209,34881,250517,23181,760861,206372,166883,196038,740381,427167,670260,419038,879898,856228,885742,722091,35692,590845,990680,115465,592461,493578,733390,732338,469645,156858,411631,818762,41684,574619,560994,751515,977727,1042985,11407,73919,85251,780728,39082,44574,407666,394655,810850,167347,461846,761498,366759,134402,638930,149956,598328,536068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]