SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 277590 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 277590 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320911,840078,486161,805006,517447,179878,899692,880343,961030,1044977,29700,177952,391100,667919,876243,639083,437745,803420,10615,1015798,703058,394556,27039,402586,651942,326381,80909,366137,226335,343016,713927,14472,588308,1030071,852729,109442,765549,944199,762061,612158,86599,801396,802402,1026917,643881,937183,229054,773664,1042549,1013642,526613,640393,745610,831414,105357,645075,603094,412764,568152,410163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 277590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 277590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]