SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017794 LIMIT 1 [ RunTime:0.000731s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017794 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824441,874052,64043,386606,880306,601945,638785,80499,801114,875734,703040,629050,225341,270664,886084,112215,305284,497139,921186,904535,708949,144935,505070,94780,237054,1040821,940087,836022,495677,970062,718843,773899,666744,854206,945122,19802,910944,1010789,374003,946146,339691,263379,607876,751910,639953,106742,774645,685554,429696,846425,314193,544950,305316,1004857,369821,87119,228102,894531,4296,156040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]