SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104676 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104676 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510818,11076,80737,1011925,37873,171895,226263,432203,596795,996587,402148,984444,906523,740048,164896,762130,67548,641575,958681,1027334,233123,544434,888093,289587,610185,819337,687871,970082,642298,1011442,1043492,62284,213415,622338,431660,24397,299636,729316,113254,18139,723835,362237,119587,14507,324670,97676,505136,225076,1041747,184958,143704,594150,721967,734635,683002,939738,777884,634993,1035202,1013640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]