SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196060 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196060 [ RunTime:0.003113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940767,143143,351707,526030,250384,221534,991165,980310,370488,63861,433143,842656,1027155,387010,608294,273404,790164,415478,26114,482492,258616,747910,850533,98434,923231,511944,677851,703587,833764,218084,608756,328597,885687,36844,710424,339976,31994,693541,956006,77896,873051,544100,658853,522468,23874,426349,891620,437143,957071,341621,915478,527566,370885,94055,142861,440731,1032143,480486,178122,241424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]