SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014230 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014230 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738658,478724,376051,712115,438399,629613,751824,5434,893331,675256,725490,516000,428373,479439,189617,924181,913537,562834,717629,119339,713327,885148,416141,413480,897049,250128,494388,346561,6254,325310,880976,957970,606919,139289,815499,514219,241733,271253,1004127,43789,381235,264966,466327,780748,827807,980100,634773,59487,947373,587521,746317,591079,55435,714141,581935,688902,767450,867217,888679,811953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]