SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429 [ RunTime:0.002337s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396494,385311,646211,1014912,547183,140244,333832,341428,658073,237488,113541,727568,541172,810186,331932,998174,877387,758288,150480,445534,789338,467170,469656,924880,362230,291824,231492,530137,227540,614872,473098,723823,219674,916298,575871,387953,587148,426657,281005,882161,847228,228934,362506,408782,427384,129870,56993,636204,659253,251176,828654,221364,476104,738361,139734,1012278,733420,861929,800124,668923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]