SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809851 LIMIT 1 [ RunTime:0.005658s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809851 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (874336,745265,535400,395486,301754,775688,813356,908901,794774,679260,860261,690033,1047221,40008,863008,886404,281955,679629,712493,33868,226938,966760,497848,830931,489810,829767,184266,1019137,26255,133837,746761,964230,128058,247725,578408,849907,780187,899448,769446,62021,630742,745289,392300,2252,981468,957084,2670,52805,653168,565573,350738,387266,124540,366219,58364,77084,787301,257416,78880,561990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]