SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512000 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512000 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455309,545401,508976,871135,760867,333896,684366,276033,36357,451295,444942,252559,621648,1017430,509351,670905,951478,807954,983644,830455,748681,905190,166520,432305,57774,716003,622157,542875,89447,39218,567281,794548,1041701,679594,39382,528439,967209,772208,938612,516142,980897,373805,942904,515599,24980,264050,352083,799989,137652,1030813,81279,958349,323230,959854,495452,338264,368833,549469,279504,110097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]