SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568618 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568618 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47182,387776,775109,923016,626272,72179,523679,1048857,137554,249355,193562,354677,672574,661543,772078,282560,235061,839345,948971,840371,350177,466876,946344,297568,402907,495322,408657,936474,902819,106248,8134,803780,753053,528471,304887,79055,216405,694958,534674,408552,240543,489399,724199,535487,508079,82918,497280,452448,601970,85236,260766,914092,511219,541785,152730,617406,989649,376829,834131,508729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]