SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310474 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310474 [ RunTime:0.003728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607031,601497,114392,1035971,65243,506875,925721,1024793,408290,966595,820989,829376,259928,55024,68371,428064,717927,19043,523612,225848,74902,765247,608063,994153,538282,675724,990637,999030,733544,602860,913340,60518,660828,768209,93293,757001,698681,778673,518994,993856,1009229,264009,37182,479482,271181,410254,177374,91079,665336,16499,1026725,620586,142304,475797,423659,330450,690303,400562,668379,1039035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]