SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502030 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502030 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790412,513967,100814,356836,792729,862032,934411,204176,670771,10511,347913,891763,724071,890164,344285,832834,757779,9086,208814,750396,27885,492043,969083,51894,293454,377351,683600,673982,32934,617070,684425,775145,678328,726165,526638,608763,726994,270493,486059,769581,1020460,217645,922851,901285,63153,844523,16453,771340,327508,121254,191600,928727,167467,12554,61872,497195,577254,794775,1040832,951084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]