SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428079 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428079 [ RunTime:0.003918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854547,811286,337466,108744,1020197,853713,442711,458494,257186,155719,880996,800678,215648,443658,120449,169742,800275,376050,1007277,636377,443737,1028604,772937,681029,831426,253586,732304,190211,144760,133410,677594,2998,832608,865499,393021,343940,301448,488980,318309,40004,408383,601502,419162,832219,295394,629317,1020352,705267,682747,923134,310850,784349,220189,488381,539538,136324,361952,170670,792180,658886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]