SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 902104 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 902104 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436914,447085,198598,147352,687257,299626,980012,222031,489543,246460,131431,783854,592702,155502,147579,782871,124036,475197,922860,728154,720652,746887,436020,730538,122616,116988,887742,362286,547351,578842,118837,890543,456349,204852,256869,110833,629692,509221,978338,587734,91137,786543,124122,383749,292382,290284,3756,491787,517560,734096,622453,836463,240902,243965,58404,771638,100086,171638,889267,579924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 902104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 902104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]