SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596178 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596178 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101092,180143,909940,100031,9692,342534,114734,475354,334587,668582,314382,665305,1042494,576247,817108,385948,527088,238588,966363,749991,315099,99810,288048,520800,442195,102151,393429,344614,488071,299402,613179,106640,541437,814935,831565,948183,435518,1005746,760850,892183,375774,834170,972823,394923,162321,586689,588446,361332,791446,931405,963409,447668,414635,725098,687763,90857,510418,509115,754333,238638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]