SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416301 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416301 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907668,254768,841570,1044387,990689,374648,264314,14163,281421,569864,384233,515797,59793,611636,563411,549663,343296,90640,114507,677615,987013,227795,336849,40019,295685,691480,564785,69696,572890,821895,305733,793014,427172,583661,905736,448214,214058,977532,991978,247385,274429,289929,353776,491883,685736,715881,421061,181878,332402,465917,18843,274422,603298,5292,349635,613141,489235,831181,986315,656747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003175s ]