SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200362 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200362 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596701,407177,819791,370554,1031882,921688,458377,313017,191590,703711,616712,744698,117624,339964,126117,835096,348308,725802,471513,849758,357934,701232,428235,105122,443843,53202,529885,18936,282522,609285,363078,821788,721168,1025844,887254,87939,709148,62648,438097,529672,960263,652699,619249,402847,275426,717983,342258,441296,255322,715587,763036,179185,877910,551274,870143,1011969,541250,276044,76364,1015586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001820s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]