SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 716801 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 716801 [ RunTime:0.003573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528179,178403,781422,741938,392629,536742,614025,908401,68871,69748,388564,993633,445070,217452,801005,314681,376179,148112,620365,24105,603299,547218,605743,1023230,99885,897132,628516,888308,542392,901558,211984,1039563,422322,77468,684237,804544,465455,885878,613086,769471,1009121,625976,249873,878262,639746,734758,769442,214402,875666,570571,847200,905217,893899,677431,477386,906523,401446,827623,469095,410444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 716801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 716801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]