SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201417 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201417 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957916,1014081,653126,878215,880225,531963,354371,219040,636248,616474,812124,87845,315841,266170,438490,287446,755091,754370,285007,73725,329877,33080,138472,14782,135242,248797,458235,856074,611931,135153,884992,98827,914610,450161,289185,543599,770057,691021,813596,657197,643438,549617,170665,179863,774749,658211,800501,808129,801424,573106,265150,800523,547934,22184,265763,692280,104173,845129,78477,986659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]