SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439940 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439940 [ RunTime:0.003123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872011,366668,638465,296138,844257,139575,321593,17027,951773,466687,281749,753503,730628,474455,158918,1044875,19098,1021838,391063,122207,236523,809301,989879,293224,58842,174994,361792,856890,383734,804740,810890,333263,503955,649620,360193,866292,1034954,856651,754815,61989,678298,441260,90488,834171,751948,222126,15253,502926,726635,720166,807417,480829,206342,488549,22316,387947,354827,510203,977945,1007339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]