SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781034 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781034 [ RunTime:0.002397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028610,907578,791290,678651,1015382,672301,316093,751261,386540,489629,731645,302662,443844,700471,662409,241879,404416,951065,163777,493390,47964,702057,893432,676230,252033,1033491,473171,173272,727382,739451,847768,590695,989727,415283,606007,615418,689152,347575,1023833,832700,708914,324891,310784,230265,556887,915966,295525,731512,855218,940459,433211,65987,372822,140704,644479,86773,625533,693694,281570,979853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001120s ]