SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910540,516428,691347,883589,6222,262871,212064,223567,75386,653932,807846,702103,958193,466691,127417,498786,370669,283655,656391,1041242,679112,924846,311436,298956,279798,232363,166166,252885,884966,54561,303241,761898,171448,487241,508549,911540,49598,679205,897084,884513,624791,30220,406642,723078,753494,139261,938198,126275,934726,997344,619880,921168,1011180,791153,698296,429871,409294,609009,229329,700249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]