SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440178 LIMIT 1 [ RunTime:0.004291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440178 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189150,498471,986974,962425,523043,829778,225314,844045,183784,338705,123663,13821,941737,870857,448358,148521,193153,201941,437889,666417,32671,174794,656982,343804,329613,126103,748373,585853,138060,290382,340173,395865,754750,855583,924012,19023,68810,875519,835007,18712,457126,948616,209547,301758,865004,351738,988773,638069,280554,1019522,273434,929837,748325,638345,156375,40045,241043,153367,760221,140725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]