SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019726 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019726 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442944,115984,528993,48044,724243,454649,10368,47002,822507,711081,957112,1025542,540717,186400,339768,732199,149387,687976,1037735,583986,319959,224740,558783,171452,9695,31675,863384,907647,273604,419251,522697,675511,421429,793879,875186,299574,593137,248630,282850,354875,869172,606367,490325,557457,818239,4929,705520,14633,820662,192150,690713,258436,442290,1025192,775879,443228,626376,836129,437961,899010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]