SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419075 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419075 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242986,725042,203458,235895,1020337,74060,401405,625035,78350,317329,705025,890722,92482,530801,286614,830940,17044,614366,911903,1017424,44346,301739,203248,398033,346330,1014762,732437,924199,715505,197709,319610,978137,42078,1045249,643648,571449,331581,262081,443607,1021639,517759,395157,962952,659514,827812,13129,151996,505374,28885,222733,385038,308283,519580,943266,261594,186942,4790,82224,397987,60245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]