SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984508 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984508 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638688,752287,802460,117044,705352,122340,352884,871239,558251,853222,880748,476144,228564,125464,554691,453394,891077,525038,318327,21979,265276,408127,376424,277988,266013,810947,99268,301394,467408,289062,683663,1034514,1033153,979288,469950,460885,712144,713061,175554,352043,212975,929931,174169,1037212,640316,395516,332717,200333,829905,456144,557652,793256,380887,522953,942521,921739,785596,497183,537421,629663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002102s ]