SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387804 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387804 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180991,878875,607261,1016123,978056,31813,694510,880063,302911,155942,266197,111554,546577,520213,669648,285509,501819,739555,300477,203349,7001,1016531,780506,925079,812910,674944,99046,167905,988713,442992,21151,247960,333763,194491,674796,565369,494626,561054,698619,305365,878553,444748,4167,554339,660786,75137,571871,105791,109217,970799,404220,991638,863810,481074,334019,102082,869264,827368,210301,888403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]