SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 728023 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 728023 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578720,882408,530453,225260,36962,536755,654302,1031580,92754,946030,284351,439508,272958,632369,637568,335654,960547,988092,652769,780446,364786,884396,765459,471458,734676,730306,2324,813999,861201,571290,386756,501057,483380,160049,684742,917023,292587,51918,783259,844433,640386,383133,798321,755446,529386,577071,317052,15504,860039,935393,625992,615062,145724,534222,523394,709947,746854,720592,655999,948844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 728023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 728023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]