SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491704 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491704 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252044,618971,540837,790845,243850,216510,937470,53670,130018,867392,943358,753324,633584,64976,110025,83621,776442,826447,903054,677270,378983,786944,476736,331707,773324,334318,371347,577822,138497,903175,359321,570779,122525,482039,423209,213498,328292,476077,515963,468325,741056,715595,260338,770699,488703,103749,993457,34931,854380,627303,290971,159823,256532,643452,826798,923577,728929,536650,296047,173611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002419s ]