SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 740541 LIMIT 1 [ RunTime:0.000823s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 740541 [ RunTime:0.003279s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538152,284550,385469,437132,745396,779619,777521,518895,43404,710394,381418,398145,788631,952634,128417,817889,550516,340235,890769,483911,699875,611893,121411,840889,374784,350232,216769,905504,226692,462852,439066,513488,455224,1039701,602971,224647,932971,594365,221159,120856,230858,481371,942055,33014,533447,654607,471095,789387,342364,857166,911433,222736,1045624,744673,873924,484500,156529,506708,922634,135294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 740541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 740541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]