SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610583 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610583 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210563,672703,641506,632554,153055,52086,216774,535732,292293,441146,101778,70596,329283,396454,516255,265402,106621,834486,352606,337933,228107,273756,124616,399393,300021,876161,138846,786980,839657,703607,522929,249297,44958,79892,162273,202340,1003469,331060,261606,61453,936380,280744,685207,755561,320940,124201,30419,96523,991598,621293,167204,404886,428056,696455,898765,418711,977438,161561,232371,376877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]