SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51775 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51775 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288558,196072,87500,9068,201691,388020,794067,796771,149070,141785,71085,305264,193501,403149,805050,125678,185038,192076,784540,783042,140101,740311,398760,49330,381567,395006,939589,488147,58253,473404,835947,773387,1014571,37932,43015,623627,334799,19856,243815,848483,280287,562026,848834,248685,311626,506896,559883,805569,40478,335453,437124,515946,654247,244793,532532,94208,662125,262845,431779,350309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]