SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415505 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415505 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704301,973998,209009,660114,481880,274834,102502,138091,301222,811310,645426,727182,263727,1041017,398140,829984,43340,144514,412279,350679,921135,504287,90316,838108,724402,670961,133974,627144,343607,862898,115721,470919,674223,893960,765183,26663,1001054,262534,59731,286906,339052,789500,263010,988608,332629,706060,881046,57262,478469,49927,1035147,564019,492285,48018,747497,593642,894690,208932,325792,741199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]