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` = 843283 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 843283 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (309327,961977,702431,194227,867676,384570,190879,972819,1042265,592243,933307,675814,271343,1025997,1021181,116433,658095,250458,712494,515449,246440,690525,178625,303798,770099,757406,341389,552369,263594,748968,1005982,734100,906737,308507,610351,627609,195780,335480,260062,458124,482036,279296,1011406,496317,881991,621912,89062,430627,1035193,727437,1042632,238576,677733,214236,731944,908182,263425,572353,364564,1006128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 843283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 843283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]