SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311113 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311113 [ RunTime:0.005376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869746,893415,85246,732,361780,409260,425775,183952,669851,610364,214006,820618,796324,1021100,871713,756514,408731,813349,43300,229126,146102,883485,1043553,940137,360517,262930,619836,776172,801616,1011926,584555,589003,280008,251604,423980,261794,12971,660803,802815,657279,214688,935827,233708,944388,320764,886141,82457,950028,881409,1031120,606368,517451,211906,403327,708064,331414,979120,970542,427713,155760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]