SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513883 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513883 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904984,814175,267381,664067,401366,184635,628590,170403,604337,809943,1016653,176103,152840,116231,938480,459479,100195,53183,242002,253250,210708,282626,523164,647565,687158,869902,247451,300128,400303,1017036,972291,168759,585811,992877,203905,1000105,418407,241978,68082,715122,254889,694020,766832,528853,347203,306479,1026074,349171,1011837,841043,136752,703306,35026,579276,523432,9960,537033,660367,339150,12340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]