SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326501 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326501 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102478,21493,1006971,105706,599671,807681,1045220,181808,218804,270921,578100,283828,458478,189917,403152,199120,708357,796049,850741,443099,257353,390689,687481,927980,910957,300827,662446,155733,1012015,430700,179707,562878,502106,183802,914773,177023,1021526,197152,801104,561769,400815,815010,329493,628474,940921,544998,310813,476713,901073,118150,142417,635679,556141,445499,115292,195524,693344,772440,303420,855357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]