SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331953 LIMIT 1 [ RunTime:0.000606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331953 [ RunTime:0.004218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042528,214909,653420,495604,425903,825092,366296,585185,620991,690485,382587,627640,946296,109299,816393,590283,317183,602587,286524,953852,569807,664201,843440,564190,341518,1013053,876265,198034,301268,199941,509738,119433,821383,700942,303046,955234,306016,932787,276374,783191,491744,92462,684313,111588,921091,459319,334083,553891,62353,526249,210221,648958,639682,487220,349807,110638,395522,233146,898316,277091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]