SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284710 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284710 [ RunTime:0.003630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340200,449560,809248,246698,341913,957076,121879,491531,118810,921232,97608,1028205,838127,557864,442650,103296,378288,718674,173380,647506,99571,881294,924499,956834,446958,1032330,253046,974731,979529,509867,684637,566726,205313,348101,43335,253865,803304,943678,606899,921821,35626,387043,1023200,788424,555331,555064,631043,643184,88001,571880,305906,151660,585433,95521,63038,918961,351231,511762,136154,452582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]