SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522863 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522863 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170203,259660,742368,684818,79215,1042207,357397,246813,48665,324950,594444,172959,309162,498183,960233,763657,103003,709637,916568,559418,448931,698823,328561,921350,441876,507267,942581,516231,506293,490094,886393,1025753,417706,374001,703492,898703,511373,164683,1028016,144237,188701,937767,950709,184714,38052,135093,547223,261946,913386,209321,214080,177724,966091,140360,749826,929687,871574,821722,461060,466425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]