SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034538 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034538 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445199,951510,408052,637214,1031975,787788,429382,527966,1033048,766176,261718,543706,178320,131050,654674,942912,739028,586363,735403,116084,336668,888654,272139,197153,1007503,724196,568214,566006,189810,319236,458351,703067,321011,620536,379237,119589,809075,315913,947999,793122,1000521,217768,759425,54241,725056,715896,20747,95736,1029125,938572,654436,510103,431835,860904,443709,310790,178895,42013,127099,964793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001378s ]