SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036563 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036563 [ RunTime:0.003035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516702,721876,79417,944013,1040565,374768,52944,515277,498736,1016655,63592,471591,983471,903867,754518,652410,843672,486985,19457,129976,385008,645918,646389,359579,556980,972808,391084,296582,456830,121864,800083,271058,143752,968890,49113,927934,855946,723657,316106,387256,298479,382236,564834,466260,106971,562924,662390,622331,550323,332499,446745,1016182,920204,274372,48607,691294,457724,884760,1014819,895069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000798s ]