SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020077 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020077 [ RunTime:0.005530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1184,942595,93836,775421,186268,680767,748681,1017739,505991,228611,628875,836752,978377,573910,456947,624231,1028866,306248,204945,871880,996819,395260,315720,120029,380660,832045,262572,235289,734495,635448,881314,315165,347499,932100,922803,158660,874832,340297,108223,622636,732841,95787,89502,603091,921505,814679,889582,1015466,444589,503649,569559,145804,884761,780643,813523,813385,237628,475663,231524,195897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004905s ]