SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530080 LIMIT 1 [ RunTime:0.001408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530080 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501238,178567,689157,359879,137430,396239,1039953,937513,939079,618386,1020002,261652,188377,461783,964127,571354,409276,154793,320773,807977,990667,400070,249691,456401,698227,642448,392417,16073,972192,322390,278889,17286,473931,629749,833831,424063,483294,671889,982157,1028795,448428,42441,584967,7511,36336,920952,101461,963168,931184,822531,260055,636478,134559,62767,754305,968613,749002,316643,37123,1018303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]