SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422975 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422975 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15684,111484,864290,1031996,706714,545090,74345,408458,431539,591253,738046,384808,977481,697226,403031,252111,162114,305389,660262,255713,959573,387392,76926,328444,254601,743218,357958,130053,198915,682522,980690,756977,441383,803963,870559,539015,323647,245947,459921,379189,537999,740096,1015642,372288,789840,464198,844298,60021,1047218,148456,1007672,530813,224940,275028,808795,524244,424805,548640,313229,871398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]