SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403113 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403113 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695026,544652,290873,418540,553029,365318,597324,675306,963927,958415,1026377,785413,661618,714125,545739,474081,698324,89804,855765,936046,900191,356780,322915,11549,389856,861307,476548,219092,235172,900578,348517,531376,357377,919539,742855,891053,29031,514739,907718,499182,552495,470700,605906,197304,431505,430647,652139,128578,880989,321975,387933,147785,90284,282910,95541,154416,231219,240920,395914,416046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]