SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204158 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204158 [ RunTime:0.002827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251105,807486,803233,451382,659977,51478,595295,375762,351531,246215,235688,19980,756896,238595,151293,823707,1029747,941719,827190,395573,709056,874108,438949,998753,600835,805980,35348,160146,78748,141578,949653,124867,554486,436598,158247,346100,909809,727122,891453,349450,419877,839885,982789,1002400,515402,608279,717908,28287,557215,397154,422685,918980,275379,961503,383190,915362,985875,618715,987483,294419) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]