SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 852008 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 852008 [ RunTime:0.002331s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333804,461933,535887,1031051,167457,45926,215666,501589,218413,18464,319098,147983,457643,583963,802442,64684,1002894,1007915,539756,294921,980834,1024586,343941,963172,263224,525815,531987,735821,535531,969029,814689,31261,194271,54510,36257,540863,443371,811991,616910,532705,235754,572275,500427,184071,304522,246217,653071,873868,679590,958706,296389,725413,396063,694097,733133,102040,546784,770819,993564,129054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 852008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 852008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]